package ph.com.gs3.formalistics.model.tables;

public class OutgoingUploadsTable {

	public static final String NAME = "Outgoing_Uploads";

	public static final String COL_ID = "_id";
	public static final String COL_LOCAL_FILE_LOCATION = "local_file_location";
	public static final String COL_UPLOAD_FOLDER_DESTINATION = "upload_folder_destination";
	public static final String COL_OWNER_ID = "owner_id";

	public static final String[] COLUMN_COLLECTION = { COL_ID, COL_LOCAL_FILE_LOCATION,
	        COL_UPLOAD_FOLDER_DESTINATION, COL_OWNER_ID };

	// @formatter:off
	public static final String CREATION_QUERY = "CREATE TABLE " + NAME + "("
			+ COL_ID						+ " INTEGER PRIMARY KEY AUTOINCREMENT, "
			+ COL_LOCAL_FILE_LOCATION 		+ " TEXT NOT NULL, "
			+ COL_UPLOAD_FOLDER_DESTINATION	+ " TEXT NOT NULL, "
			+ COL_OWNER_ID 					+ " INTEGER NOT NULL"
			+ ");";
	// @formatter:on

}
